DBC-Zorgproducten per jaar, specialisme, diagnose

Dataset statistics

Number of variables	14
Number of observations	346213
Missing cells	54115
Missing cells (%)	1.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	37.0 MiB
Average record size in memory	112.0 B

Variable types

Categorical	3
DateTime	1
Numeric	9
Text	1

Alerts

`VERSIE` has constant value ""	Constant
`DATUM_BESTAND` has constant value ""	Constant
`PEILDATUM` has constant value ""	Constant
`GEMIDDELDE_VERKOOPPRIJS` has 54115 (15.6%) missing values	Missing
`AANTAL_SUBTRAJECT_PER_ZPD` is highly skewed (γ1 = 21.44392654)	Skewed

Reproduction

Analysis started	2023-12-05 15:42:30.642729
Analysis finished	2023-12-05 15:42:47.668550
Duration	17.03 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

VERSIE
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

1.0	346213

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1038639
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	346213	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	346213	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	346213	33.3%
.	346213	33.3%
0	346213	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	692426	66.7%
Other Punctuation	346213	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	346213	50.0%
0	346213	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	346213	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1038639	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	346213	33.3%
.	346213	33.3%
0	346213	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1038639	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	346213	33.3%
.	346213	33.3%
0	346213	33.3%

DATUM_BESTAND
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

2023-11-20	346213

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	3462130
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2023-11-20
2nd row	2023-11-20
3rd row	2023-11-20
4th row	2023-11-20
5th row	2023-11-20

Common Values

Value	Count	Frequency (%)
2023-11-20	346213	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023-11-20	346213	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	1038639	30.0%
0	692426	20.0%
-	692426	20.0%
1	692426	20.0%
3	346213	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2769704	80.0%
Dash Punctuation	692426	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	1038639	37.5%
0	692426	25.0%
1	692426	25.0%
3	346213	12.5%

Dash Punctuation

Value	Count	Frequency (%)
-	692426	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3462130	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	1038639	30.0%
0	692426	20.0%
-	692426	20.0%
1	692426	20.0%
3	346213	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3462130	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	1038639	30.0%
0	692426	20.0%
-	692426	20.0%
1	692426	20.0%
3	346213	10.0%

PEILDATUM
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

2023-11-01	346213

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	3462130
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2023-11-01
2nd row	2023-11-01
3rd row	2023-11-01
4th row	2023-11-01
5th row	2023-11-01

Common Values

Value	Count	Frequency (%)
2023-11-01	346213	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023-11-01	346213	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	1038639	30.0%
2	692426	20.0%
0	692426	20.0%
-	692426	20.0%
3	346213	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2769704	80.0%
Dash Punctuation	692426	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	1038639	37.5%
2	692426	25.0%
0	692426	25.0%
3	346213	12.5%

Dash Punctuation

Value	Count	Frequency (%)
-	692426	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3462130	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	1038639	30.0%
2	692426	20.0%
0	692426	20.0%
-	692426	20.0%
3	346213	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3462130	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	1038639	30.0%
2	692426	20.0%
0	692426	20.0%
-	692426	20.0%
3	346213	10.0%

JAAR
Date

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

Minimum	2012-01-01 00:00:00
Maximum	2023-01-01 00:00:00

Histogram

Histogram with fixed size bins (bins=12)

BEHANDELEND_SPECIALISME_CD
Real number (ℝ)

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	451.02967

Minimum	301
Maximum	8418
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	301
5-th percentile	302
Q1	305
median	313
Q3	322
95-th percentile	361
Maximum	8418
Range	8117
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	1038.9564
Coefficient of variation (CV)	2.3035212
Kurtosis	54.718454
Mean	451.02967
Median Absolute Deviation (MAD)	8
Skewness	7.5263612
Sum	1.5615234 × 10⁸
Variance	1079430.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
305	48557	14.0%
313	44934	13.0%
303	39831	11.5%
330	27329	7.9%
316	23541	6.8%
308	18724	5.4%
306	14541	4.2%
324	14202	4.1%
301	13845	4.0%
304	11282	3.3%
Other values (18)	89427	25.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
301	13845	4.0%
302	7624	2.2%
303	39831	11.5%
304	11282	3.3%
305	48557	14.0%
306	14541	4.2%
307	6072	1.8%
308	18724	5.4%
310	3779	1.1%
313	44934	13.0%

Value	Count	Frequency (%)
8418	4680	1.4%
8416	1100	0.3%
1900	229	0.1%
390	954	0.3%
389	3622	1.0%
362	4447	1.3%
361	2517	0.7%
335	3495	1.0%
330	27329	7.9%
329	905	0.3%

TYPERENDE_DIAGNOSE_CD
Text

Distinct	1902
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

Length

Max length	4
Median length	3
Mean length	3.3528204
Min length	2

Characters and Unicode

Total characters	1160790
Distinct characters	25
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10 ?
Unique (%)	< 0.1%

Sample

1st row	F21
2nd row	M16
3rd row	B15
4th row	K24
5th row	G23

Value	Count	Frequency (%)
101	1481	0.4%
402	1422	0.4%
403	1396	0.4%
301	1392	0.4%
201	1321	0.4%
203	1290	0.4%
401	1166	0.3%
404	1152	0.3%
409	1124	0.3%
802	1122	0.3%
Other values (1892)	333347	96.3%

Most occurring characters

Value	Count	Frequency (%)
1	221967	19.1%
0	213288	18.4%
2	153832	13.3%
3	125578	10.8%
5	89585	7.7%
9	83562	7.2%
4	82225	7.1%
7	68396	5.9%
6	60608	5.2%
8	50020	4.3%
Other values (15)	11729	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1149061	99.0%
Uppercase Letter	11729	1.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	2187	18.6%
M	1972	16.8%
B	1424	12.1%
Z	1014	8.6%
E	984	8.4%
D	769	6.6%
A	761	6.5%
F	729	6.2%
C	386	3.3%
K	379	3.2%
Other values (5)	1124	9.6%

Decimal Number

Value	Count	Frequency (%)
1	221967	19.3%
0	213288	18.6%
2	153832	13.4%
3	125578	10.9%
5	89585	7.8%
9	83562	7.3%
4	82225	7.2%
7	68396	6.0%
6	60608	5.3%
8	50020	4.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	1149061	99.0%
Latin	11729	1.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	2187	18.6%
M	1972	16.8%
B	1424	12.1%
Z	1014	8.6%
E	984	8.4%
D	769	6.6%
A	761	6.5%
F	729	6.2%
C	386	3.3%
K	379	3.2%
Other values (5)	1124	9.6%

Common

Value	Count	Frequency (%)
1	221967	19.3%
0	213288	18.6%
2	153832	13.4%
3	125578	10.9%
5	89585	7.8%
9	83562	7.3%
4	82225	7.2%
7	68396	6.0%
6	60608	5.3%
8	50020	4.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1160790	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	221967	19.1%
0	213288	18.4%
2	153832	13.3%
3	125578	10.8%
5	89585	7.7%
9	83562	7.2%
4	82225	7.1%
7	68396	5.9%
6	60608	5.2%
8	50020	4.3%
Other values (15)	11729	1.0%

ZORGPRODUCT_CD
Real number (ℝ)

Distinct	6196
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.4118692 × 10⁸

Minimum	10501002
Maximum	9.9841808 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	10501002
5-th percentile	28999040
Q1	99799067
median	1.4959903 × 10⁸
Q3	9.90004 × 10⁸
95-th percentile	9.9051605 × 10⁸
Maximum	9.9841808 × 10⁸
Range	9.8791708 × 10⁸
Interquartile range (IQR)	8.9020494 × 10⁸

Descriptive statistics

Standard deviation	4.2906031 × 10⁸
Coefficient of variation (CV)	0.97251366
Kurtosis	-1.7391839
Mean	4.4118692 × 10⁸
Median Absolute Deviation (MAD)	1.1960003 × 10⁸
Skewness	0.46571714
Sum	1.5274465 × 10¹⁴
Variance	1.8409275 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
990004009	2534	0.7%
990004007	2488	0.7%
990003004	2394	0.7%
990004006	2021	0.6%
990356076	1850	0.5%
990356073	1718	0.5%
131999228	1696	0.5%
131999164	1670	0.5%
990003007	1549	0.4%
131999194	1524	0.4%
Other values (6186)	326769	94.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10501002	9	< 0.1%
10501003	12	< 0.1%
10501004	12	< 0.1%
10501005	12	< 0.1%
10501007	3	< 0.1%
10501008	12	< 0.1%
10501010	12	< 0.1%
10501011	3	< 0.1%
11101002	11	< 0.1%
11101003	12	< 0.1%

Value	Count	Frequency (%)
998418081	176	0.1%
998418080	160	< 0.1%
998418079	40	< 0.1%
998418077	9	< 0.1%
998418076	9	< 0.1%
998418075	7	< 0.1%
998418074	240	0.1%
998418073	241	0.1%
998418072	9	< 0.1%
998418071	9	< 0.1%

AANTAL_PAT_PER_ZPD
Real number (ℝ)

Distinct	10449
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	510.89698

Minimum	1
Maximum	165184
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	13
Q3	102
95-th percentile	1725
Maximum	165184
Range	165183
Interquartile range (IQR)	99

Descriptive statistics

Standard deviation	3178.1465
Coefficient of variation (CV)	6.220719
Kurtosis	416.34993
Mean	510.89698
Median Absolute Deviation (MAD)	12
Skewness	16.880538
Sum	1.7687918 × 10⁸
Variance	10100615
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	57494	16.6%
2	28055	8.1%
3	18371	5.3%
4	13374	3.9%
5	10511	3.0%
6	8842	2.6%
7	7418	2.1%
8	6180	1.8%
9	5682	1.6%
10	5087	1.5%
Other values (10439)	185199	53.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	57494	16.6%
2	28055	8.1%
3	18371	5.3%
4	13374	3.9%
5	10511	3.0%
6	8842	2.6%
7	7418	2.1%
8	6180	1.8%
9	5682	1.6%
10	5087	1.5%

Value	Count	Frequency (%)
165184	1	< 0.1%
162461	1	< 0.1%
158301	1	< 0.1%
155869	1	< 0.1%
154539	1	< 0.1%
154258	1	< 0.1%
144714	1	< 0.1%
118396	1	< 0.1%
115935	1	< 0.1%
113248	1	< 0.1%

AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)

SKEWED

Distinct	11205
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	605.51161

Minimum	1
Maximum	240002
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	14
Q3	111
95-th percentile	1972
Maximum	240002
Range	240001
Interquartile range (IQR)	108

Descriptive statistics

Standard deviation	4102.4335
Coefficient of variation (CV)	6.7751525
Kurtosis	729.15346
Mean	605.51161
Median Absolute Deviation (MAD)	13
Skewness	21.443927
Sum	2.0963599 × 10⁸
Variance	16829961
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	55381	16.0%
2	27571	8.0%
3	18184	5.3%
4	13180	3.8%
5	10421	3.0%
6	8810	2.5%
7	7344	2.1%
8	6136	1.8%
9	5608	1.6%
10	5081	1.5%
Other values (11195)	188497	54.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	55381	16.0%
2	27571	8.0%
3	18184	5.3%
4	13180	3.8%
5	10421	3.0%
6	8810	2.5%
7	7344	2.1%
8	6136	1.8%
9	5608	1.6%
10	5081	1.5%

Value	Count	Frequency (%)
240002	1	< 0.1%
232423	1	< 0.1%
231954	1	< 0.1%
230939	1	< 0.1%
227936	1	< 0.1%
227409	1	< 0.1%
226233	1	< 0.1%
223891	1	< 0.1%
218673	1	< 0.1%
215131	1	< 0.1%

AANTAL_PAT_PER_DIAG
Real number (ℝ)

Distinct	9408
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7661.0515

Minimum	1
Maximum	230662
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	40
Q1	395
median	1693
Q3	6243
95-th percentile	36749
Maximum	230662
Range	230661
Interquartile range (IQR)	5848

Descriptive statistics

Standard deviation	17896.73
Coefficient of variation (CV)	2.336067
Kurtosis	35.029884
Mean	7661.0515
Median Absolute Deviation (MAD)	1548
Skewness	5.120952
Sum	2.6523556 × 10⁹
Variance	3.2029293 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21	613	0.2%
17	523	0.2%
8	522	0.2%
26	509	0.1%
25	508	0.1%
9	502	0.1%
12	501	0.1%
19	491	0.1%
14	489	0.1%
23	477	0.1%
Other values (9398)	341078	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	402	0.1%
2	464	0.1%
3	476	0.1%
4	450	0.1%
5	477	0.1%
6	447	0.1%
7	458	0.1%
8	522	0.2%
9	502	0.1%
10	411	0.1%

Value	Count	Frequency (%)
230662	23	< 0.1%
229208	20	< 0.1%
227999	23	< 0.1%
218495	24	< 0.1%
214507	17	< 0.1%
213515	25	< 0.1%
211579	17	< 0.1%
210415	19	< 0.1%
205337	17	< 0.1%
200600	16	< 0.1%

AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ)

Distinct	10496
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11107.437

Minimum	1
Maximum	370139
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	51
Q1	523
median	2368
Q3	9066
95-th percentile	52146
Maximum	370139
Range	370138
Interquartile range (IQR)	8543

Descriptive statistics

Standard deviation	26862.034
Coefficient of variation (CV)	2.4183828
Kurtosis	38.366335
Mean	11107.437
Median Absolute Deviation (MAD)	2178
Skewness	5.3546399
Sum	3.845539 × 10⁹
Variance	7.2156889 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17	442	0.1%
25	436	0.1%
23	424	0.1%
3	410	0.1%
4	397	0.1%
20	397	0.1%
6	396	0.1%
10	391	0.1%
13	387	0.1%
34	387	0.1%
Other values (10486)	342146	98.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	317	0.1%
2	337	0.1%
3	410	0.1%
4	397	0.1%
5	368	0.1%
6	396	0.1%
7	364	0.1%
8	355	0.1%
9	293	0.1%
10	391	0.1%

Value	Count	Frequency (%)
370139	23	< 0.1%
365382	23	< 0.1%
350959	20	< 0.1%
348482	25	< 0.1%
344610	24	< 0.1%
341651	19	< 0.1%
323753	20	< 0.1%
315771	17	< 0.1%
310754	17	< 0.1%
298627	17	< 0.1%

AANTAL_PAT_PER_SPC
Real number (ℝ)

Distinct	325
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	665955.03

Minimum	1610
Maximum	1487632
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1610
5-th percentile	41749
Q1	260836
median	757846
Q3	1026293
95-th percentile	1332313
Maximum	1487632
Range	1486022
Interquartile range (IQR)	765457

Descriptive statistics

Standard deviation	418497.13
Coefficient of variation (CV)	0.6284165
Kurtosis	-1.1773654
Mean	665955.03
Median Absolute Deviation (MAD)	319233
Skewness	0.011544625
Sum	2.3056229 × 10¹¹
Variance	1.7513984 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
880928	5102	1.5%
874088	4354	1.3%
843978	4347	1.3%
894305	4333	1.3%
880465	4273	1.2%
897698	4212	1.2%
765015	4089	1.2%
803555	4028	1.2%
781731	3993	1.2%
1080721	3890	1.1%
Other values (315)	303592	87.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1610	130	< 0.1%
1829	138	< 0.1%
1920	131	< 0.1%
2495	173	< 0.1%
2553	190	0.1%
2862	102	< 0.1%
4140	168	< 0.1%
5156	68	< 0.1%
6117	331	0.1%
6805	380	0.1%

Value	Count	Frequency (%)
1487632	2975	0.9%
1450390	3048	0.9%
1421702	3564	1.0%
1344256	3543	1.0%
1340565	3441	1.0%
1332313	3545	1.0%
1316350	3463	1.0%
1282933	3576	1.0%
1278266	3370	1.0%
1267046	3350	1.0%

AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)

Distinct	325
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1080927.3

Minimum	1861
Maximum	2664173
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1861
5-th percentile	46341
Q1	378547
median	1087900
Q3	1808514
95-th percentile	2548166
Maximum	2664173
Range	2662312
Interquartile range (IQR)	1429967

Descriptive statistics

Standard deviation	753404.17
Coefficient of variation (CV)	0.69699799
Kurtosis	-0.829534
Mean	1080927.3
Median Absolute Deviation (MAD)	716868
Skewness	0.3690758
Sum	3.7423109 × 10¹¹
Variance	5.6761784 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1211797	5102	1.5%
1281482	4354	1.3%
1216253	4347	1.3%
1315564	4333	1.3%
1300429	4273	1.2%
1341821	4212	1.2%
1155933	4089	1.2%
1205563	4028	1.2%
1157648	3993	1.2%
2548166	3890	1.1%
Other values (315)	303592	87.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1861	130	< 0.1%
2097	138	< 0.1%
2195	131	< 0.1%
2816	173	< 0.1%
3052	102	< 0.1%
3321	190	0.1%
4946	168	< 0.1%
5427	68	< 0.1%
6300	331	0.1%
7384	380	0.1%

Value	Count	Frequency (%)
2664173	3866	1.1%
2662911	3793	1.1%
2618563	3789	1.1%
2593432	3843	1.1%
2548166	3890	1.1%
2514582	3889	1.1%
2479950	3851	1.1%
2178503	3757	1.1%
2062152	3811	1.1%
2052147	1168	0.3%

GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)

MISSING

Distinct	3640
Distinct (%)	1.2%
Missing	54115
Missing (%)	15.6%
Infinite	0
Infinite (%)	0.0%
Mean	3594.7539

Minimum	70
Maximum	287220
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	70
5-th percentile	140
Q1	480
median	1250
Q3	4175
95-th percentile	13710
Maximum	287220
Range	287150
Interquartile range (IQR)	3695

Descriptive statistics

Standard deviation	6523.3583
Coefficient of variation (CV)	1.8146884
Kurtosis	138.49976
Mean	3594.7539
Median Absolute Deviation (MAD)	1020
Skewness	6.9966081
Sum	1.0500204 × 10⁹
Variance	42554203
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
160	2100	0.6%
105	1977	0.6%
110	1791	0.5%
180	1614	0.5%
300	1607	0.5%
185	1580	0.5%
140	1515	0.4%
175	1474	0.4%
125	1388	0.4%
165	1384	0.4%
Other values (3630)	275668	79.6%
(Missing)	54115	15.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
70	226	0.1%
75	75	< 0.1%
80	362	0.1%
85	919	0.3%
90	663	0.2%
95	727	0.2%
100	1019	0.3%
105	1977	0.6%
110	1791	0.5%
115	1156	0.3%

Value	Count	Frequency (%)
287220	8	< 0.1%
148910	3	< 0.1%
142835	4	< 0.1%
122155	4	< 0.1%
116765	3	< 0.1%
109725	7	< 0.1%
108570	7	< 0.1%
107655	4	< 0.1%
101270	8	< 0.1%
99590	5	< 0.1%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	VERSIE	DATUM_BESTAND	PEILDATUM	JAAR	BEHANDELEND_SPECIALISME_CD	TYPERENDE_DIAGNOSE_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
0	1.0	2023-11-20	2023-11-01	2021-01-01	307	F21	972804022	3604	4439	25371	82809	716328	1196259	1510.0
1	1.0	2023-11-20	2023-11-01	2021-01-01	307	M16	20108156	23	112	5829	10817	716328	1196259	835.0
2	1.0	2023-11-20	2023-11-01	2021-01-01	307	B15	159899004	2	2	247	247	716328	1196259	10860.0
3	1.0	2023-11-20	2023-11-01	2021-01-01	307	K24	159899020	1054	1101	1457	1574	716328	1196259	330.0
4	1.0	2023-11-20	2023-11-01	2021-01-01	307	G23	149399026	380	403	57993	75171	716328	1196259	2110.0
5	1.0	2023-11-20	2023-11-01	2021-01-01	307	Z28	159999033	752	767	4147	4823	716328	1196259	605.0
6	1.0	2023-11-20	2023-11-01	2021-01-01	307	F11	972804024	2	2	37991	54989	716328	1196259	670.0
7	1.0	2023-11-20	2023-11-01	2021-01-01	307	M16	20108181	372	385	5829	10817	716328	1196259	635.0
8	1.0	2023-11-20	2023-11-01	2021-01-01	307	G25	149999045	6	6	58583	90324	716328	1196259	NaN
9	1.0	2023-11-20	2023-11-01	2021-01-01	307	K25	59899008	2	2	19	20	716328	1196259	NaN

	VERSIE	DATUM_BESTAND	PEILDATUM	JAAR	BEHANDELEND_SPECIALISME_CD	TYPERENDE_DIAGNOSE_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
346203	1.0	2023-11-20	2023-11-01	2014-01-01	303	841	990356051	2	2	11	16	1421702	1845615	3840.0
346204	1.0	2023-11-20	2023-11-01	2015-01-01	362	221	990062015	2	2	463	492	70900	81597	1450.0
346205	1.0	2023-11-20	2023-11-01	2020-01-01	313	079	979002311	1	1	26	62	1046961	2618563	NaN
346206	1.0	2023-11-20	2023-11-01	2014-01-01	303	856	149399040	1	1	9	11	1421702	1845615	220.0
346207	1.0	2023-11-20	2023-11-01	2020-01-01	313	762	979003009	2	3	203	1844	1046961	2618563	22785.0
346208	1.0	2023-11-20	2023-11-01	2020-01-01	320	701	979001223	4	4	5218	8393	1030959	1831046	6655.0
346209	1.0	2023-11-20	2023-11-01	2020-01-01	313	078	979002314	1	1	332	870	1046961	2618563	4845.0
346210	1.0	2023-11-20	2023-11-01	2014-01-01	303	222	199299068	1	1	7666	9519	1421702	1845615	4640.0
346211	1.0	2023-11-20	2023-11-01	2014-01-01	303	293	131999214	2	2	1313	1777	1421702	1845615	340.0
346212	1.0	2023-11-20	2023-11-01	2014-01-01	303	288	131999099	1	1	222	271	1421702	1845615	1940.0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Missing values

Sample